JavaWeb:用户信息管理系统

您所在的位置：网站首页 › java web 管理系统 › JavaWeb:用户信息管理系统

JavaWeb:用户信息管理系统

2024-07-05 08:17| 来源: 网络整理| 查看: 265

目录：前言：一、需求分析：1. 简单功能2. 复杂功能3.登录：二、设计：1. 技术选型：2. 数据库设计：三、开发：1. 环境搭建1. 创建数据库环境（mysql8.0）2. 创建项目，导入需要的jar包 2. 编码四：测试五. 部署运维最难不过坚持！加油！

前言：

通过这几天在B站上学习的JSP，MVC开发模式，EL表达式，JSTL，三层架构：软件设计架构，等JavaWeb知识，于是乎跟着视频做了一个用户信息管理系统，在此记录一下，以巩固所学知识。

一、需求分析： 1. 简单功能 1. 列表查询 2. 登录 3. 添加 4. 删除 5. 修改 2. 复杂功能 1. 删除选中 2. 分页查询好处： 1. 减轻服务器内存的开销 2. 提升用户体验 3. 复杂条件查询 3.登录：调整页面，加入验证码功能代码实现二、设计： 1. 技术选型：

Servlet+JSP+MySQL+JDBCTempleat+Duird+BeanUtilS+tomcat

2. 数据库设计： drop database if exists day17; create database day17; use day17; create table user( id int primary key auto_increment, name varchar(20) not null, gender varchar(5), age int, address varchar(32), qq varchar(20), email varchar(50), username varchar(20), password varchar(32) ); insert into user values(1,"小A","男",20,"北京","112233","[email protected]","小A","123456"); insert into user values(2,"小B","女",20,"上海","112234","[email protected]","小B","123456"); insert into user values(3,"小C","男",20,"北京","112235","[email protected]","小C","123456"); insert into user values(4,"小D","女",20,"上海","112236","[email protected]",null,null); insert into user values(5,"小E","男",20,"北京","112237","[email protected]",null,null); insert into user values(6,"小F","女",20,"上海","112238","[email protected]",null,null); insert into user values(7,"小G","男",20,"北京","112239","[email protected]",null,null); insert into user values(8,"小H","女",20,"上海","112240","[email protected]",null,null); insert into user values(9,"小I","男",20,"北京","112241","[email protected]",null,null); insert into user values(10,"小J","女",20,"上海","112242","[email protected]",null,null); insert into user values(11,"小K","男",20,"北京","112243","[email protected]",null,null); insert into user values(12,"小L","女",20,"上海","112244","[email protected]",null,null); insert into user values(13,"小M","男",20,"北京","112245","[email protected]",null,null); insert into user values(14,"小N","女",20,"上海","112246","[email protected]",null,null); insert into user values(15,"小O","男",20,"北京","112247","[email protected]",null,null);

初始我设置系统有三位管理员：小A,小B,小C,密码为123456. （个人随机设置，可以改动）其他记录为普通用户。

三、开发： 1. 环境搭建 1. 创建数据库环境（mysql8.0）创建数据库:day17;user表:存取用户信息 2. 创建项目，导入需要的jar包

在这里插入图片描述